JA Job Board Component 8,554 posts

[Rob Hawthorn Friend Rob HawthornJoin date: September 2014Posts: 190Downloads:0Uploads:28 Thanks: 38 Thanked: 3 times in 1 posts]

#143519

Hi, I’ve got multiple locations to upload and don’t want to spend days typing them all in, is it possible to upload these to the corresponding joomla file or a batch update?

[beastmode54 JA JobBoard beastmode54Join date: November 2007Posts: 233Downloads:0Uploads:4 Thanks: 12 Thanked: 20 times in 1 posts]

#314640

You would have to do an import into the table in the mysql database…unless JA intergrades this option.

[Rob Hawthorn Friend Rob HawthornJoin date: September 2014Posts: 190Downloads:0Uploads:28 Thanks: 38 Thanked: 3 times in 1 posts]

#314641

Thanks, you wouldn’t know which table it is do you? I’ve not actually done any inserts that way before but it makes sense to do it that way. My SQL is entry level to say the least though.

[beastmode54 JA JobBoard beastmode54Join date: November 2007Posts: 233Downloads:0Uploads:4 Thanks: 12 Thanked: 20 times in 1 posts]

#314645

I believe its JA_locations…in my regular job i do a little SQL..ill see if i can figure out something

[Nick R JA JobBoard Nick RJoin date: August 2009Posts: 284Downloads:0Uploads:9 Thanks: 12 Thanked: 20 times in 1 posts]

#314698

If you are using phpmyadmin, try to first make a backup, then go to the locations table, select it and say export and save it.
Edit the saved file with an editor. You will see how the locations should look like.
Go back to phpmyadmin and import the new saved document.
WARNING: I didnt tried this and dont know if its working, but this is the way how i would try it.

1 user says Thank You to Nick R for this useful post

1. Rob Hawthorn

[mingotn Friend mingotnJoin date: August 2009Posts: 2Downloads:0Uploads:0]

#314708

If anyone figures out how to do this please post, i’ve been wondering how to do this myself

[beastmode54 JA JobBoard beastmode54Join date: November 2007Posts: 233Downloads:0Uploads:4 Thanks: 12 Thanked: 20 times in 1 posts]

#314717

Good idea..im not to familiar with phpmyadmin..but it looks like it would work.

[Rob Hawthorn Friend Rob HawthornJoin date: September 2014Posts: 190Downloads:0Uploads:28 Thanks: 38 Thanked: 3 times in 1 posts]

#314736

<em>@algmed 141230 wrote:</em><blockquote>If you are using phpmyadmin, try to first make a backup, then go to the locations table, select it and say export and save it.
Edit the saved file with an editor. You will see how the locations should look like.
Go back to phpmyadmin and import the new saved document.
WARNING: I didnt tried this and dont know if its working, but this is the way how i would try it.</blockquote>

Thanks algmed I’ll give it a go

[Hung Dinh Friend Hung DinhJoin date: September 2014Posts: 4408Downloads:11Uploads:189 Thanks: 309 Thanked: 3310 times in 3 posts]

#314931

Cities & Locations information updated via XML is an interesting features, we ll consider to include in the coming major release eg: 1.2.0

[sandstorm871 Friend sandstorm871Join date: November 2009Posts: 55Downloads:10Uploads:3 Thanks: 2]

#335346

Was the XML Locations thing added? Im using latest version 1.4.2 and cant seem to find an easy way to add UK only locations without typing them in or messing about with phpmy admin.

Any advice/help appreciated.

Andy

[Author]

Posts