Jump to content

Search the Community

Showing results for tags 'import'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 5 results

  1. Can I import data in RAR format?
  2. I'm trying to import a simple one row of test data and one row of column names. It gives me an unknown format message. I've tried using .xls, xlsx, even csv. Nothing works. I've read the forum messages and there is no clear cut solution. What's the secret?
  3. I don't know why but Caspio is not letting me upload .jpeg or .png files, individually or even when they're zipped in the 'Files' folder. Any idea why this could be happening? THanks,
  4. I'm trying to create an FTP scheduled task with an FTP URL. It is similar to this: ftp://xxxxxxx:pppppppp@idx.living.net/idx_fl_ftp_down/idx_naples_dn/naples_data.zip I do not have directory rights, I can only retrieve the file. How do I use the task scheduler for this type of connection?
  5. I am new to Caspio and attempting to create my first application. I was attempting to import my data and ran into a problem with a table skipping records with the following message: The table contains unique fields with duplicate or blank values. These values were not imported The statement is an impossibility because my source data has a defined primary key. My source table is located in a SQL database and I exported it to a flat file for import into Caspio. The structure of the source table is shown below: CREATE TABLE FacilityAddresses ( FacilityAddressID UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL CONSTRAINT DF_FacilityAddresses_FacilityAddressID DEFAULT (NEWID()), FacilityID UNIQUEIDENTIFIER NOT NULL, AddressID UNIQUEIDENTIFIER NOT NULL, Priority INT NOT NULL, CONSTRAINT PK_FacilityAddresses PRIMARY KEY CLUSTERED (FacilityAddressID ASC) ON PRIMARY FacilityAddressID is a Primary Key and is not duplicated FacilityID is a foreign key to the Facilities table AddressID is a foreign key to the Addresses table There are duplicate FacilityIDs in the table. This is necessary as a facility may have more than one address. There are also duplicate AddressIDs in the table. This too is necessary as some facilities share an address. I don't know how the import tool is determining that there are duplicate values, There are three GUIDs in the table, but the combination of all three is unique. It must be seeing that there are duplicates in the columns individually, but if this is the case how can one ever create a table with foreign keys? Any help would be appreciated.
×
×
  • Create New...